namespace CRM.DataAccess.Entities
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("CONTACTS")]
    public partial class CONTACT
    {
        public long ID { get; set; }

        public bool DELETED { get; set; }

        public long? CREATED_BY { get; set; }

        public DateTime DATE_ENTERED { get; set; }

        public long? MODIFIED_USER_ID { get; set; }

        public DateTime DATE_MODIFIED { get; set; }

        public long? TEAM_ID { get; set; }

        public long? SALUTATION_ID { get; set; }

        [StringLength(100)]
        public string SUR_NAME { get; set; }

        [StringLength(100)]
        public string NAME { get; set; }

        [StringLength(25)]
        public string PHONE_OFFICE { get; set; }

        public long? ORGANIZATION_ID { get; set; }

        [StringLength(25)]
        public string PHONE_MOBILE { get; set; }

        public long? LEAD_SOURCE_ID { get; set; }

        [StringLength(25)]
        public string PHONE_HOME { get; set; }

        [StringLength(50)]
        public string DESIGNATION { get; set; }

        [StringLength(25)]
        public string PHONE_SECONDARY { get; set; }

        [StringLength(100)]
        public string DEPARTMENT { get; set; }

        [StringLength(25)]
        public string FAX { get; set; }

        [StringLength(100)]
        public string PRIMARY_EMAIL { get; set; }

        public DateTime? DATE_OF_BIRTH { get; set; }

        [StringLength(100)]
        public string SECONDARY_EMAIL { get; set; }

        public bool? DO_NOT_CALL { get; set; }

        public long? ASSIGNED_USER_ID { get; set; }

        [StringLength(255)]
        public string PORTAL_USER { get; set; }

        public DateTime? SUPPORT_START_DATE { get; set; }

        public DateTime? SUPPORT_END_DATE { get; set; }

        [StringLength(150)]
        public string OFFICE_STREET { get; set; }

        [StringLength(150)]
        public string HOME_STREET { get; set; }

        [StringLength(100)]
        public string OFFICE_PO_BOX { get; set; }

        [StringLength(100)]
        public string HOME_PO_BOX { get; set; }

        [StringLength(100)]
        public string OFFICE_CITY { get; set; }

        [StringLength(100)]
        public string HOME_CITY { get; set; }

        [StringLength(100)]
        public string OFFICE_STATE { get; set; }

        [StringLength(100)]
        public string HOME_STATE { get; set; }

        [StringLength(100)]
        public string OFFICE_ZIP { get; set; }

        [StringLength(100)]
        public string HOME_ZIP { get; set; }

        [StringLength(100)]
        public string OFFICE_COUNTRY { get; set; }

        [StringLength(100)]
        public string HOME_COUNTRY { get; set; }

        public string PICTURE { get; set; }

        public long? STATUS_ID { get; set; }

        [StringLength(1000)]
        public string STATUS_NOTE { get; set; }

        public double POINTS { get; set; }

        public double LIFE_TIME_POINTS { get; set; }

        [StringLength(250)]
        public string LOYALTY_NAME { get; set; }

        public long? LOYALTY_ID { get; set; }

        public long? LOYALTY_STARTER_ID { get; set; }

        [StringLength(10)]
        public string STATUS_FINAL_STEP { get; set; }
    }
}
